package idea.innovacion.interfaces;

import idea.innovacion.bean.IdeaDTO;

import java.sql.SQLException;
import java.util.ArrayList;

public interface IIdeaDAO {

	
	public boolean insertIdea(IdeaDTO dto) throws SQLException;
	
	public void deleteIdea(IdeaDTO dto) throws SQLException;
	
	public void updateIdea(IdeaDTO dto) throws SQLException;

	public ArrayList<IdeaDTO> listIdea() throws SQLException;
	
	public ArrayList<IdeaDTO> listIdea(String campo, String estado) throws SQLException;
	
	public Integer getTituloIdea(String titulo) throws SQLException;
	
	public Integer getEstadoIdea(String estado) throws SQLException;
	
	public boolean insertUsuarioDocente(IdeaDTO dto) throws SQLException;


}

